package tmall.portal.mapper;


import org.apache.ibatis.annotations.*;
import tmall.framework.eobj.SegmentEobj;
import tmall.portal.eobj.UserEobj;


@Mapper
public interface UserMapper {


    @Select("SELECT user_id, username, password,status, email,createTms,phone_number FROM tmall_user where username = #{username}")
    @Results(value = {
            @Result(column = "user_id", property = "userId"),
            @Result(column = "username", property = "username"),
            @Result(column = "password", property = "password"),
            @Result(column = "status", property = "status"),
            @Result(column = "email", property = "email"),
            @Result(column = "createTms", property = "createTms"),
            @Result(column = "phone_number", property = "phoneNumber")

    })
    public UserEobj queryUserByName(@Param("username") String username);


}
